open('/Library/WebServer/Documents/forsale.db'); } } $db = new MyDB(); if(!$db){ echo $db->lastErrorMsg(); } else { echo "Opened database successfully\n"; } $sql =<<exec($query) ){ $message = "Data is updated successfully."; }else{ $message = "Sorry, Data is not updated."; } } $id = $_GET['id']; // rowid from url // Prepar the query to get the row data with rowid $query = "SELECT RECORD, * FROM forsale WHERE RECORD=$id"; $result = $db->query($query); $data = $result->fetchArray(); // set the row in $data ?> Update Data
Name:
Model:
Desc:
Picture:
Condition:
Price:
Back
http://www.w3programmers.com/simple-crud-php-sqlite-database/